mail.altrad.com/2015.02.mail.altrad.com.tar/mail.altrad.com/TEST/office deutch/ACCESS.NL-NL/ACCLR.CAB/ACCESS_TEMPLATE_ASSETS.ACCDT_1043/template/database/objects/queryContactsExtendedFlipName.txt

Text File | 2006-11-12 | 4KB | 105 lines

Operation =1
Option =0
Begin InputTables
    Name ="Contacts"
End
Begin OutputColumns
    Alias ="File As"
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
    Alias ="Contact Name"
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
    Expression ="Contacts.*"
End
Begin OrderBy
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
    Flag =0
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbBoolean "TotalsRow" ="0"
dbBinary "GUID" = Begin
    0x5195dfa1f2d4f64e8b3e0000494ae398
End
dbLongBinary "DOL" = Begin
    0x0acc0e55000000004802068f71449c44a9f2c03f36ec4a3f000000002bffe443 ,
    0x570ae340010000004029283443006f006e007400610063007400730000000000 ,
    0x0000ec96e6af686f0441b0e2672fb8bb10fd070000005195dfa1f2d4f64e8b3e ,
    0x0000494ae398460069006c0065002000410073000000000000000b8c708367ec ,
    0x4446bc18bd8854c6e514070000005195dfa1f2d4f64e8b3e0000494ae3984300 ,
    0x6f006e00740061006300740020004e0061006d0065000000000000005e70b4fa ,
    0x1c446b4097a6867289505780070000004802068f71449c44a9f2c03f36ec4a3f ,
    0x4c0061007300740020004e0061006d0065000000000000003e8d3bb15292dd4e ,
    0xb10a1776b3854c3b070000004802068f71449c44a9f2c03f36ec4a3f46006900 ,
    0x72007300740020004e0061006d0065000000000000003919900d9b336b43b5d2 ,
    0x650bb6bdf187070000004802068f71449c44a9f2c03f36ec4a3f43006f006d00 ,
    0x700061006e007900000000000000000000000000000000000000000000000c00 ,
    0x0000040000000000000000000000000000000000 ,
    0x0acc0e55000000004802068f71449c44a9f2c03f36ec4a3f000000004dfbfa41 ,
    0x570ae340010000004029283443006f006e007400610063007400730000000000 ,
    0x00002b03e661f3ae7d48a0a8bafb0ab901fd070000004373c68b5210044585af ,
    0xd2ddace71c1a460069006c0065002000410073000000000000001550ae090d3f ,
    0x5246b2c6cdb1d6fb682c070000004373c68b5210044585afd2ddace71c1a4300 ,
    0x6f006e00740061006300740020004e0061006d0065000000000000005e70b4fa ,
    0x1c446b4097a6867289505780070000004802068f71449c44a9f2c03f36ec4a3f ,
    0x4c0061007300740020004e0061006d0065000000000000003e8d3bb15292dd4e ,
    0xb10a1776b3854c3b070000004802068f71449c44a9f2c03f36ec4a3f46006900 ,
    0x72007300740020004e0061006d0065000000000000003919900d9b336b43b5d2 ,
    0x650bb6bdf187070000004802068f71449c44a9f2c03f36ec4a3f43006f006d00 ,
    0x700061006e007900000000000000000000000000000000000000000000000c00 ,
    0x0000040000000000000000000000000000000000
End
Begin
    Begin
        dbText "Name" ="Contact Name"
        dbInteger "ColumnWidth" ="1695"
        dbInteger "ColumnOrder" ="1"
        dbBoolean "ColumnHidden" ="0"
        dbMemo "SmartTags" ="\"urn:schemas-microsoft-com:office:smarttags#PersonName\""
        dbLong "AggregateType" ="-1"
        dbBinary "GUID" = Begin
            0x0b8c708367ec4446bc18bd8854c6e514
        End
    End
    Begin
        dbText "Name" ="File As"
        dbInteger "ColumnWidth" ="1695"
        dbInteger "ColumnOrder" ="2"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
        dbBinary "GUID" = Begin
            0xec96e6af686f0441b0e2672fb8bb10fd
        End
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =799
    Bottom =612
    Left =-1
    Top =-1
    Right =784
    Bottom =268
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =12
        Right =192
        Bottom =156
        Top =0
        Name ="Contacts"
        Name =""
    End
End